How to define a connection to a SQL database, procedural steps included.

Connecting to databases using dynamic connection strings can be done securely.

The Close Connection to SQL Database action allows you to close a connection to a SQL database in a Desktop Application. This action must be preceded by the Connect to SQL Database action.

The Execute UPDATE Query on a SQL Database action allows you to modify one or more records in a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.

The Execute INSERT Query on a SQL Database action allows you to insert one or more records into a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.

The Execute SELECT Query on a SQL Database action allows you to execute a SQL SELECT statement (a query) on a remote SQL database (or Excel spreadsheet) to retrieve one or more record(s). Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.

The Execute DELETE Query on a SQL Database action allows you to delete one or more records from a remote SQL database. Alpha Anywhere will use AlphaDAO (Alpha Data Access Objects) to connect to the remote database.

The Export Database Tables to SQL dialog helps you export one or more Alpha Anywhere .DBF tables to a back-end SQL database.

The first step in the Flying Start Genie is to configure the AlphaDAO connection to the database with the tables and views used for the generated Grid Components.